DXL to extract First and Last name os users-DOORS 9.1

Can someone help me with a DXL script to extract the DOORS 9.1 user list (first name, last name, email) to a CSV file? since this option doesn't exist in DOORS.

Thank you.

Aljo George

Re: DXL to extract First and Last name os users-DOORS 9.1
thsturm - Tue Dec 05 03:20:46 EST 2017

/*
 * Created by: sturm
 * Creation date: 23.03.2011
 */
pragma encoding, "UTF-8"

User u
string usrProf = getenv("USERPROFILE")
string dbName = goodFileName getDatabaseName
string dbFile = usrProf "\\Desktop\\" dbName ".csv" 
Stream csv = write(dbFile, CP_UTF8)
for u in userList do {
        bool disabled = u.disabled
        string uname = u.name
        string email = u.email
        string lmail = lower email
        if (disabled) csv << "#"
        //csv << uname ";" lmail ";" dbName "\n"
        csv << lmail ";" uname ";" dbName "\n"
}

close csv
infoBox "Writing to '" dbFile "'\n"

Re: DXL to extract First and Last name os users-DOORS 9.1
AljoGeorge - Tue Dec 05 23:32:55 EST 2017

/*
 * Created by: sturm
 * Creation date: 23.03.2011
 */
pragma encoding, "UTF-8"

User u
string usrProf = getenv("USERPROFILE")
string dbName = goodFileName getDatabaseName
string dbFile = usrProf "\\Desktop\\" dbName ".csv" 
Stream csv = write(dbFile, CP_UTF8)
for u in userList do {
        bool disabled = u.disabled
        string uname = u.name
        string email = u.email
        string lmail = lower email
        if (disabled) csv << "#"
        //csv << uname ";" lmail ";" dbName "\n"
        csv << lmail ";" uname ";" dbName "\n"
}

close csv
infoBox "Writing to '" dbFile "'\n"

Thank you. I have executed this DXL script and this has extracted only the user IDs and the Email IDs. What I wanted to extract is the user First name, Last name and if possible the Email IDs. Any help would be much appreciated.

Thank you,

Aljo George

Re: DXL to extract First and Last name os users-DOORS 9.1
thsturm - Wed Dec 06 03:28:57 EST 2017

Sorry, but DOORS does not know 'First Name' and 'Last Name'. The properties are:

• name
• adress
• email
• systemLoginName
• telephone
• fullName
• and several boolean properties

You can fetch the 'fullName' and split it in first and last name.

Re: DXL to extract First and Last name os users-DOORS 9.1
PekkaMakinen - Wed Dec 06 05:03:20 EST 2017

The first name and last name values are available if DOORS is configured to use Rational Directory Server (LDAP/AD). The original poster did not specify the configuration, but if they are using RDS please research the "forename" and "surname" functions in the DXL Reference.

Edit: OK, just noticed the "DOORS 9.1" - it might be that these functions are not available in that version.

Re: DXL to extract First and Last name os users-DOORS 9.1
AljoGeorge - Wed Dec 06 22:31:04 EST 2017

We are neither using LDAP/AS or RDS-User accounts are natively created in DOORS. Our plan is to migrate 9.1 to 9.6.(latest patch) and then to DNG. So we can run the script in DOORS 9.6. We are good if we are able to extract the first name and the last name, at least.

Thank you!